#!/usr/bin/env python
# $Id: test2-20.py df54dec975f4 2012/09/09 20:22:40 pgurumur $
# Copyright (c) 2012 Prabhu Gurumurthy <pgurumur@gmail.com>
#
# Permission to use, copy, modify, and distribute this software for any
# purpose with or without fee is hereby granted, provided that the above
# copyright notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
# WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
# ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
# WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
# ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
# OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
#

__version__  = "$Revision: df54dec975f4 $"
__author__   = "$Author: pgurumur $"
__modified__ = "$Date: 2012-09-09 20:22:40Z $"

from sqlalchemy import select
from sqlalchemy import join

from venya.lib import sql

"""
select inet_ntoa(ipblock.address), entity.asnumber, bgppeering.bgppeeraddr from bgppeering left join device on device.id = bgppeering.device left join ipblock on ipblock.id = device.snmp_target left join entity on entity.id = bgppeering.entity;
"""

if __name__ == "__main__":
   handle = sql.mysql('netdot', 'sirius', 'djanet', 'oS9XckUcTAHc5rjlcPt1',
         True)
   if handle:
      bgptable = handle["bgppeering"]
      devtable = handle["device"]
      ipblock = handle["ipblock"]
      entity = handle["entity"]

      """
      for (address, device) in bgptable.q.filter(
            bgptable.bgppeeraddr == "10.42.127.5").filter(
                  bgptable.monitored == 1).values(
                  bgptable.bgppeeraddr, bgptable.device):
         print address, ipblock.q.filter(
               ipblock.id == devtable.q.filter(devtable.id == device).value(
               devtable.snmp_target)).value(ipblock.address)
               
         # print address, device
      """


      for ix, jy in handle.query(


      handle.close()
   else:
      print("no handle!")
